package org.com.coolfish.common.database.repository;

import java.util.List;

import org.com.coolfish.common.database.entity.KuyuAgent;
import org.com.coolfish.common.database.entity.KuyuAgentAccount;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

public interface KuyuAgentAccountRepository extends JpaRepository<KuyuAgentAccount, Integer> {
	
	
	
	@Query("select new KuyuAgentAccount(ago_amount) FROM KuyuAgentAccount WHERE aid =:aid")
	KuyuAgentAccount queryOldMoney(@Param("aid")Integer aid);
	
	
}
